Computer Science for IGCSE & O level - Databases (Section 2 - No. 43)

What is the purpose of a 'foreign key' in a database?

To uniquely identify records within a table.

To create relationships between tables.

To define the primary key for a table.

To sort the data in a table.

A foreign key establishes a link between tables by referencing the primary key of another table, enabling relational database functionality.